﻿/***********************************************************************************************************************************
 *    Name: dbo.events_list.sql
 *  Author: Frank Figearo — http://www.sqlnerd.me/ — frank@sqlnerd.me
 * Summary: 
**/
IF OBJECT_ID(N'dbo.events_list') IS NOT NULL DROP TABLE dbo.events_list;
CREATE TABLE dbo.events_list (
	event_id			INT				NOT NULL,
	event_name			NVARCHAR(64)	NOT NULL,
	event_description	NVARCHAR(512)	NOT NULL
	CONSTRAINT PK_Events PRIMARY KEY CLUSTERED (event_id));
SET NOCOUNT ON;
INSERT INTO dbo.events_list VALUES (10, N'RPC:Completed', N'Occurs when a remote procedure call (RPC) has completed.');
INSERT INTO dbo.events_list VALUES (11, N'RPC:Starting', N'Occurs when an RPC has started.');
INSERT INTO dbo.events_list VALUES (12, N'SQL:BatchCompleted', N'Occurs when a Transact-SQL batch has completed.');
INSERT INTO dbo.events_list VALUES (13, N'SQL:BatchStarting', N'Occurs when a Transact-SQL batch has started.');
INSERT INTO dbo.events_list VALUES (14, N'Audit Login', N'Occurs when a user successfully logs in to SQL Server.');
INSERT INTO dbo.events_list VALUES (15, N'Audit Logout', N'Occurs when a user logs out of SQL Server.');
INSERT INTO dbo.events_list VALUES (16, N'Attention', N'Occurs when attention events, such as client-interrupt requests or broken client connections, happen.');
INSERT INTO dbo.events_list VALUES (17, N'ExistingConnection', N'Detects all activity by users connected to SQL Server before the trace started.');
INSERT INTO dbo.events_list VALUES (18, N'Audit Server Starts and Stops', N'Occurs when the SQL Server service state is modified.');
INSERT INTO dbo.events_list VALUES (19, N'DTCTransaction', N'Tracks Microsoft Distributed Transaction Coordinator (MS DTC) coordinated transactions between two or more databases.');
INSERT INTO dbo.events_list VALUES (20, N'Audit Login Failed', N'Indicates that a login attempt to SQL Server from a client failed.');
INSERT INTO dbo.events_list VALUES (21, N'EventLog', N'Indicates that events have been logged in the Windows application log.');
INSERT INTO dbo.events_list VALUES (22, N'ErrorLog', N'Indicates that error events have been logged in the SQL Server error log.');
INSERT INTO dbo.events_list VALUES (23, N'Lock:Released', N'Indicates that a lock on a resource, such as a page, has been released.');
INSERT INTO dbo.events_list VALUES (24, N'Lock:Acquired', N'Indicates acquisition of a lock on a resource, such as a data page.');
INSERT INTO dbo.events_list VALUES (25, N'Lock:Deadlock', N'Indicates that two concurrent transactions have deadlocked each other by trying to obtain incompatible locks on resources the other transaction owns.');
INSERT INTO dbo.events_list VALUES (26, N'Lock:Cancel', N'Indicates that the acquisition of a lock on a resource has been canceled (for example, due to a deadlock).');
INSERT INTO dbo.events_list VALUES (27, N'Lock:Timeout', N'Indicates that a request for a lock on a resource, such as a page, has timed out due to another transaction holding a blocking lock on the required resource. Time-out is determined by the @@LOCK_TIMEOUT function, and can be set with the SET LOCK_TIMEOUT statement.');
INSERT INTO dbo.events_list VALUES (28, N'Degree of Parallelism Event (7.0 Insert)', N'Occurs before a SELECT, INSERT, or UPDATE statement is executed.');
INSERT INTO dbo.events_list VALUES (33, N'Exception', N'Indicates that an exception has occurred in SQL Server.');
INSERT INTO dbo.events_list VALUES (34, N'SP:CacheMiss', N'Indicates when a stored procedure is not found in the procedure cache.');
INSERT INTO dbo.events_list VALUES (35, N'SP:CacheInsert', N'Indicates when an item is inserted into the procedure cache.');
INSERT INTO dbo.events_list VALUES (36, N'SP:CacheRemove', N'Indicates when an item is removed from the procedure cache.');
INSERT INTO dbo.events_list VALUES (37, N'SP:Recompile', N'Indicates that a stored procedure was recompiled.');
INSERT INTO dbo.events_list VALUES (38, N'SP:CacheHit', N'Indicates when a stored procedure is found in the procedure cache.');
INSERT INTO dbo.events_list VALUES (40, N'SQL:StmtStarting', N'Occurs when the Transact-SQL statement has started.');
INSERT INTO dbo.events_list VALUES (41, N'SQL:StmtCompleted', N'Occurs when the Transact-SQL statement has completed.');
INSERT INTO dbo.events_list VALUES (42, N'SP:Starting', N'Indicates when the stored procedure has started.');
INSERT INTO dbo.events_list VALUES (43, N'SP:Completed', N'Indicates when the stored procedure has completed.');
INSERT INTO dbo.events_list VALUES (44, N'SP:StmtStarting', N'Indicates that a Transact-SQL statement within a stored procedure has started executing.');
INSERT INTO dbo.events_list VALUES (45, N'SP:StmtCompleted', N'Indicates that a Transact-SQL statement within a stored procedure has finished executing.');
INSERT INTO dbo.events_list VALUES (46, N'Object:Created', N'Indicates that an object has been created, such as for CREATE INDEX, CREATE TABLE, and CREATE DATABASE statements.');
INSERT INTO dbo.events_list VALUES (47, N'Object:Deleted', N'Indicates that an object has been deleted, such as in DROP INDEX and DROP TABLE statements.');
INSERT INTO dbo.events_list VALUES (50, N'SQL Transaction', N'Tracks Transact-SQL BEGIN, COMMIT, SAVE, and ROLLBACK TRANSACTION statements.');
INSERT INTO dbo.events_list VALUES (51, N'Scan:Started', N'Indicates when a table or index scan has started.');
INSERT INTO dbo.events_list VALUES (52, N'Scan:Stopped', N'Indicates when a table or index scan has stopped.');
INSERT INTO dbo.events_list VALUES (53, N'CursorOpen', N'Indicates when a cursor is opened on a Transact-SQL statement by ODBC, OLE DB, or DB-Library.');
INSERT INTO dbo.events_list VALUES (54, N'TransactionLog', N'Tracks when transactions are written to the transaction log.');
INSERT INTO dbo.events_list VALUES (55, N'Hash Warning', N'Indicates that a hashing operation (for example, hash join, hash aggregate, hash union, and hash distinct) that is not processing on a buffer partition has reverted to an alternate plan. This can occur because of recursion depth, data skew, trace flags, or bit counting.');
INSERT INTO dbo.events_list VALUES (58, N'Auto Stats', N'Indicates an automatic updating of index statistics has occurred.');
INSERT INTO dbo.events_list VALUES (59, N'Lock:Deadlock Chain', N'Produced for each of the events leading up to the deadlock.');
INSERT INTO dbo.events_list VALUES (60, N'Lock:Escalation', N'Indicates that a finer-grained lock has been converted to a coarser-grained lock (for example, a page lock escalated or converted to a TABLE or HoBT lock).');
INSERT INTO dbo.events_list VALUES (61, N'OLE DB Errors', N'Indicates that an OLE DB error has occurred.');
INSERT INTO dbo.events_list VALUES (67, N'Execution Warnings', N'Indicates any warnings that occurred during the execution of a SQL Server statement or stored procedure.');
INSERT INTO dbo.events_list VALUES (68, N'Showplan Text (Unencoded)', N'Displays the plan tree of the Transact-SQL statement executed.');
INSERT INTO dbo.events_list VALUES (69, N'Sort Warnings', N'Indicates sort operations that do not fit into memory. Does not include sort operations involving the creating of indexes; only sort operations within a query (such as an ORDER BY clause used in a SELECT statement).');
INSERT INTO dbo.events_list VALUES (70, N'CursorPrepare', N'Indicates when a cursor on a Transact-SQL statement is prepared for use by ODBC, OLE DB, or DB-Library.');
INSERT INTO dbo.events_list VALUES (71, N'Prepare SQL', N'ODBC, OLE DB, or DB-Library has prepared a Transact-SQL statement or statements for use.');
INSERT INTO dbo.events_list VALUES (72, N'Exec Prepared SQL', N'ODBC, OLE DB, or DB-Library has executed a prepared Transact-SQL statement or statements.');
INSERT INTO dbo.events_list VALUES (73, N'Unprepare SQL', N'ODBC, OLE DB, or DB-Library has unprepared (deleted) a prepared Transact-SQL statement or statements.');
INSERT INTO dbo.events_list VALUES (74, N'CursorExecute', N'A cursor previously prepared on a Transact-SQL statement by ODBC, OLE DB, or DB-Library is executed.');
INSERT INTO dbo.events_list VALUES (75, N'CursorRecompile', N'A cursor opened on a Transact-SQL statement by ODBC or DB-Library has been recompiled either directly or due to a schema change. Triggered for ANSI and non-ANSI cursors.');
INSERT INTO dbo.events_list VALUES (76, N'CursorImplicitConversion', N'A cursor on a Transact-SQL statement is converted by SQL Server from one type to another. Triggered for ANSI and non-ANSI cursors.');
INSERT INTO dbo.events_list VALUES (77, N'CursorUnprepare', N'A prepared cursor on a Transact-SQL statement is unprepared (deleted) by ODBC, OLE DB, or DB-Library.');
INSERT INTO dbo.events_list VALUES (78, N'CursorClose', N'A cursor previously opened on a Transact-SQL statement by ODBC, OLE DB, or DB-Library is closed.');
INSERT INTO dbo.events_list VALUES (79, N'Missing Column Statistics', N'Column statistics that could have been useful for the optimizer are not available.');
INSERT INTO dbo.events_list VALUES (80, N'Missing Join Predicate', N'Query that has no join predicate is being executed. This could result in a long-running query.');
INSERT INTO dbo.events_list VALUES (81, N'Server Memory Change', N'SQL Server memory usage has increased or decreased by either 1 megabyte (MB) or 5 percent of the maximum server memory, whichever is greater.');
INSERT INTO dbo.events_list VALUES (92, N'Data File Auto Grow', N'Indicates that a data file was extended automatically by the server.');
INSERT INTO dbo.events_list VALUES (93, N'Log File Auto Grow', N'Indicates that a log file was extended automatically by the server.');
INSERT INTO dbo.events_list VALUES (94, N'Data File Auto Shrink', N'Indicates that a data file was shrunk automatically by the server.');
INSERT INTO dbo.events_list VALUES (95, N'Log File Auto Shrink', N'Indicates that a log file was shrunk automatically by the server.');
INSERT INTO dbo.events_list VALUES (96, N'Showplan Text', N'Displays the query plan tree of the SQL statement from the query optimizer. Note that the TextData column does not contain the Showplan for this event.');
INSERT INTO dbo.events_list VALUES (97, N'Showplan All', N'Displays the query plan with full compile-time details of the SQL statement executed. Note that the TextData column does not contain the Showplan for this event.');
INSERT INTO dbo.events_list VALUES (98, N'Showplan Statistics Profile', N'Displays the query plan with full run-time details of the SQL statement executed. Note that the TextData column does not contain the Showplan for this event.');
INSERT INTO dbo.events_list VALUES (100, N'RPC Output Parameter', N'Produces output values of the parameters for every RPC.');
INSERT INTO dbo.events_list VALUES (102, N'Audit Database Scope GDR', N'Occurs every time a GRANT, DENY, REVOKE for a statement permission is issued by any user in SQL Server for database-only actions such as granting permissions on a database.');
INSERT INTO dbo.events_list VALUES (103, N'Audit Object GDR Event', N'Occurs every time a GRANT, DENY, REVOKE for an object permission is issued by any user in SQL Server.');
INSERT INTO dbo.events_list VALUES (104, N'Audit AddLogin Event', N'Occurs when a SQL Server login is added or removed; for sp_addlogin and sp_droplogin.');
INSERT INTO dbo.events_list VALUES (105, N'Audit Login GDR Event', N'Occurs when a Windows login right is added or removed; for sp_grantlogin, sp_revokelogin, and sp_denylogin.');
INSERT INTO dbo.events_list VALUES (106, N'Audit Login Change Property Event', N'Occurs when a property of a login, except passwords, is modified; for sp_defaultdb and sp_defaultlanguage.');
INSERT INTO dbo.events_list VALUES (107, N'Audit Login Change Password Event', N'Occurs when a SQL Server login password is changed. Passwords are not recorded.');
INSERT INTO dbo.events_list VALUES (108, N'Audit Add Login to Server Role Event', N'Occurs when a login is added or removed from a fixed server role; for sp_addsrvrolemember, and sp_dropsrvrolemember.');
INSERT INTO dbo.events_list VALUES (109, N'Audit Add DB User Event', N'Occurs when a login is added or removed as a database user (Windows or SQL Server) to a database; for sp_grantdbaccess, sp_revokedbaccess, sp_adduser, and sp_dropuser.');
INSERT INTO dbo.events_list VALUES (110, N'Audit Add Member to DB Role Event', N'Occurs when a login is added or removed as a database user (fixed or user-defined) to a database; for sp_addrolemember, sp_droprolemember, and sp_changegroup.');
INSERT INTO dbo.events_list VALUES (111, N'Audit Add Role Event', N'Occurs when a login is added or removed as a database user to a database; for sp_addrole and sp_droprole.');
INSERT INTO dbo.events_list VALUES (112, N'Audit App Role Change Password Event', N'Occurs when a password of an application role is changed.');
INSERT INTO dbo.events_list VALUES (113, N'Audit Statement Permission Event', N'Occurs when a statement permission (such as CREATE TABLE) is used.');
INSERT INTO dbo.events_list VALUES (114, N'Audit Schema Object Access Event', N'Occurs when an object permission (such as SELECT) is used, both successfully or unsuccessfully.');
INSERT INTO dbo.events_list VALUES (115, N'Audit Backup/Restore Event', N'Occurs when a BACKUP or RESTORE command is issued.');
INSERT INTO dbo.events_list VALUES (116, N'Audit DBCC Event', N'Occurs when DBCC commands are issued.');
INSERT INTO dbo.events_list VALUES (117, N'Audit Change Audit Event', N'Occurs when audit trace modifications are made.');
INSERT INTO dbo.events_list VALUES (118, N'Audit Object Derived Permission Event', N'Occurs when a CREATE, ALTER, and DROP object commands are issued.');
INSERT INTO dbo.events_list VALUES (119, N'OLEDB Call Event', N'Occurs when OLE DB provider calls are made for distributed queries and remote stored procedures.');
INSERT INTO dbo.events_list VALUES (120, N'OLEDB QueryInterface Event', N'Occurs when OLE DB QueryInterface calls are made for distributed queries and remote stored procedures.');
INSERT INTO dbo.events_list VALUES (121, N'OLEDB DataRead Event', N'Occurs when a data request call is made to the OLE DB provider.');
INSERT INTO dbo.events_list VALUES (122, N'Showplan XML', N'Occurs when an SQL statement executes. Include this event to identify Showplan operators. Each event is stored in a well-formed XML document. Note that the Binary column for this event contains the encoded Showplan. Use SQL Server Profiler to open the trace and view the Showplan.');
INSERT INTO dbo.events_list VALUES (123, N'SQL:FullTextQuery', N'Occurs when a full text query executes.');
INSERT INTO dbo.events_list VALUES (124, N'Broker:Conversation', N'Reports the progress of a Service Broker conversation.');
INSERT INTO dbo.events_list VALUES (125, N'Deprecation Announcement', N'Occurs when you use a feature that will be removed from a future version of SQL Server.');
INSERT INTO dbo.events_list VALUES (126, N'Deprecation Final Support', N'Occurs when you use a feature that will be removed from the next major release of SQL Server.');
INSERT INTO dbo.events_list VALUES (127, N'Exchange Spill Event', N'Occurs when communication buffers in a parallel query plan have been temporarily written to the tempdb database.');
INSERT INTO dbo.events_list VALUES (128, N'Audit Database Management Event', N'Occurs when a database is created, altered, or dropped.');
INSERT INTO dbo.events_list VALUES (129, N'Audit Database Object Management Event', N'Occurs when a CREATE, ALTER, or DROP statement executes on database objects, such as schemas.');
INSERT INTO dbo.events_list VALUES (130, N'Audit Database Principal Management Event', N'Occurs when principals, such as users, are created, altered, or dropped from a database.');
INSERT INTO dbo.events_list VALUES (131, N'Audit Schema Object Management Event', N'Occurs when server objects are created, altered, or dropped.');
INSERT INTO dbo.events_list VALUES (132, N'Audit Server Principal Impersonation Event', N'Occurs when there is an impersonation within server scope, such as EXECUTE AS LOGIN.');
INSERT INTO dbo.events_list VALUES (133, N'Audit Database Principal Impersonation Event', N'Occurs when an impersonation occurs within the database scope, such as EXECUTE AS USER or SETUSER.');
INSERT INTO dbo.events_list VALUES (134, N'Audit Server Object Take Ownership Event', N'Occurs when the owner is changed for objects in server scope.');
INSERT INTO dbo.events_list VALUES (135, N'Audit Database Object Take Ownership Event', N'Occurs when a change of owner for objects within database scope occurs.');
INSERT INTO dbo.events_list VALUES (136, N'Broker:Conversation Group', N'Occurs when Service Broker creates a new conversation group or drops an existing conversation group.');
INSERT INTO dbo.events_list VALUES (137, N'Blocked Process Report', N'Occurs when a process has been blocked for more than a specified amount of time. Does not include system processes or processes that are waiting on non deadlock-detectable resources. Use sp_configure to configure the threshold and frequency at which reports are generated.');
INSERT INTO dbo.events_list VALUES (138, N'Broker:Connection', N'Reports the status of a transport connection managed by Service Broker.');
INSERT INTO dbo.events_list VALUES (139, N'Broker:Forwarded Message Sent', N'Occurs when Service Broker forwards a message.');
INSERT INTO dbo.events_list VALUES (140, N'Broker:Forwarded Message Dropped', N'Occurs when Service Broker drops a message that was intended to be forwarded.');
INSERT INTO dbo.events_list VALUES (141, N'Broker:Message Classify', N'Occurs when Service Broker determines the routing for a message.');
INSERT INTO dbo.events_list VALUES (142, N'Broker:Transmission', N'Indicates that errors have occurred in the Service Broker transport layer. The error number and state values indicate the source of the error.');
INSERT INTO dbo.events_list VALUES (143, N'Broker:Queue Disabled', N'Indicates a poison message was detected because there were five consecutive transaction rollbacks on a Service Broker queue. The event contains the database ID and queue ID of the queue that contains the poison message.');
INSERT INTO dbo.events_list VALUES (146, N'Showplan XML Statistics Profile', N'Occurs when an SQL statement executes. Identifies the Showplan operators and displays complete, compile-time data. Note that the Binary column for this event contains the encoded Showplan. Use SQL Server Profiler to open the trace and view the Showplan.');
INSERT INTO dbo.events_list VALUES (148, N'Deadlock Graph', N'Occurs when an attempt to acquire a lock is canceled because the attempt was part of a deadlock and was chosen as the deadlock victim. Provides an XML description of a deadlock.');
INSERT INTO dbo.events_list VALUES (149, N'Broker:Remote Message Acknowledgement', N'Occurs when Service Broker sends or receives a message acknowledgement.');
INSERT INTO dbo.events_list VALUES (150, N'Trace File Close', N'Occurs when a trace file closes during a trace file rollover.');
INSERT INTO dbo.events_list VALUES (152, N'Audit Change Database Owner', N'Occurs when ALTER AUTHORIZATION is used to change the owner of a database and permissions are checked to do that.');
INSERT INTO dbo.events_list VALUES (153, N'Audit Schema Object Take Ownership Event', N'Occurs when ALTER AUTHORIZATION is used to assign an owner to an object and permissions are checked to do that.');
INSERT INTO dbo.events_list VALUES (155, N'FT:Crawl Started', N'Occurs when a full-text crawl (population) starts. Use to check if a crawl request is picked up by worker tasks.');
INSERT INTO dbo.events_list VALUES (156, N'FT:Crawl Stopped', N'Occurs when a full-text crawl (population) stops. Stops occur when a crawl completes successfully or when a fatal error occurs.');
INSERT INTO dbo.events_list VALUES (157, N'FT:Crawl Aborted', N'Occurs when an exception is encountered during a full-text crawl. Usually causes the full-text crawl to stop.');
INSERT INTO dbo.events_list VALUES (158, N'Audit Broker Conversation', N'Reports audit messages related to Service Broker dialog security.');
INSERT INTO dbo.events_list VALUES (159, N'Audit Broker Login', N'Reports audit messages related to Service Broker transport security.');
INSERT INTO dbo.events_list VALUES (160, N'Broker:Message Undeliverable', N'Occurs when Service Broker is unable to retain a received message that should have been delivered to a service.');
INSERT INTO dbo.events_list VALUES (161, N'Broker:Corrupted Message', N'Occurs when Service Broker receives a corrupted message.');
INSERT INTO dbo.events_list VALUES (162, N'User Error Message', N'Displays error messages that users see in the case of an error or exception.');
INSERT INTO dbo.events_list VALUES (163, N'Broker:Activation', N'Occurs when a queue monitor starts an activation stored procedure, sends a QUEUE_ACTIVATION notification, or when an activation stored procedure started by a queue monitor exits.');
INSERT INTO dbo.events_list VALUES (164, N'Object:Altered', N'Occurs when a database object is altered.');
INSERT INTO dbo.events_list VALUES (165, N'Performance statistics', N'Occurs when a compiled query plan has been cached for the first time, recompiled, or removed from the plan cache.');
INSERT INTO dbo.events_list VALUES (166, N'SQL:StmtRecompile', N'Occurs when a statement-level recompilation occurs.');
INSERT INTO dbo.events_list VALUES (167, N'Database Mirroring State Change', N'Occurs when the state of a mirrored database changes.');
INSERT INTO dbo.events_list VALUES (168, N'Showplan XML For Query Compile', N'Occurs when an SQL statement compiles. Displays the complete, compile-time data. Note that the Binary column for this event contains the encoded Showplan. Use SQL Server Profiler to open the trace and view the Showplan.');
INSERT INTO dbo.events_list VALUES (169, N'Showplan All For Query Compile', N'Occurs when an SQL statement compiles. Displays complete, compile-time data. Use to identify Showplan operators.');
INSERT INTO dbo.events_list VALUES (170, N'Audit Server Scope GDR Event', N'Indicates that a grant, deny, or revoke event for permissions in server scope occurred, such as creating a login.');
INSERT INTO dbo.events_list VALUES (171, N'Audit Server Object GDR Event', N'Indicates that a grant, deny, or revoke event for a schema object, such as a table or function, occurred.');
INSERT INTO dbo.events_list VALUES (172, N'Audit Database Object GDR Event', N'Indicates that a grant, deny, or revoke event for database objects, such as assemblies and schemas, occurred.');
INSERT INTO dbo.events_list VALUES (173, N'Audit Server Operation Event', N'Occurs when Security Audit operations such as altering settings, resources, external access, or authorization are used.');
INSERT INTO dbo.events_list VALUES (175, N'Audit Server Alter Trace Event', N'Occurs when a statement checks for the ALTER TRACE permission.');
INSERT INTO dbo.events_list VALUES (176, N'Audit Server Object Management Event', N'Occurs when server objects are created, altered, or dropped.');
INSERT INTO dbo.events_list VALUES (177, N'Audit Server Principal Management Event', N'Occurs when server principals are created, altered, or dropped.');
INSERT INTO dbo.events_list VALUES (178, N'Audit Database Operation Event', N'Occurs when database operations occur, such as checkpoint or subscribe query notification.');
INSERT INTO dbo.events_list VALUES (180, N'Audit Database Object Access Event', N'Occurs when database objects, such as schemas, are accessed.');
INSERT INTO dbo.events_list VALUES (181, N'TM: Begin Tran starting', N'Occurs when a BEGIN TRANSACTION request starts.');
INSERT INTO dbo.events_list VALUES (182, N'TM: Begin Tran completed', N'Occurs when a BEGIN TRANSACTION request completes.');
INSERT INTO dbo.events_list VALUES (183, N'TM: Promote Tran starting', N'Occurs when a PROMOTE TRANSACTION request starts.');
INSERT INTO dbo.events_list VALUES (184, N'TM: Promote Tran completed', N'Occurs when a PROMOTE TRANSACTION request completes.');
INSERT INTO dbo.events_list VALUES (185, N'TM: Commit Tran starting', N'Occurs when a COMMIT TRANSACTION request starts.');
INSERT INTO dbo.events_list VALUES (186, N'TM: Commit Tran completed', N'Occurs when a COMMIT TRANSACTION request completes.');
INSERT INTO dbo.events_list VALUES (187, N'TM: Rollback Tran starting', N'Occurs when a ROLLBACK TRANSACTION request starts.');
INSERT INTO dbo.events_list VALUES (188, N'TM: Rollback Tran completed', N'Occurs when a ROLLBACK TRANSACTION request completes.');
INSERT INTO dbo.events_list VALUES (189, N'Lock:Timeout (timeout > 0)', N'Occurs when a request for a lock on a resource, such as a page, times out.');
INSERT INTO dbo.events_list VALUES (190, N'Progress Report: Online Index Operation', N'Reports the progress of an online index build operation while the build process is running.');
INSERT INTO dbo.events_list VALUES (191, N'TM: Save Tran starting', N'Occurs when a SAVE TRANSACTION request starts.');
INSERT INTO dbo.events_list VALUES (192, N'TM: Save Tran completed', N'Occurs when a SAVE TRANSACTION request completes.');
INSERT INTO dbo.events_list VALUES (193, N'Background Job Error', N'Occurs when a background job terminates abnormally.');
INSERT INTO dbo.events_list VALUES (194, N'OLEDB Provider Information', N'Occurs when a distributed query runs and collects information corresponding to the provider connection.');
INSERT INTO dbo.events_list VALUES (195, N'Mount Tape', N'Occurs when a tape mount request is received.');
INSERT INTO dbo.events_list VALUES (196, N'Assembly Load', N'Occurs when a request to load a CLR assembly occurs.');
INSERT INTO dbo.events_list VALUES (198, N'XQuery Static Type', N'Occurs when an XQuery expression is executed. This event class provides the static type of the XQuery expression.');
INSERT INTO dbo.events_list VALUES (199, N'QN: subscription', N'Occurs when a query registration cannot be subscribed. The TextData column contains information about the event.');
INSERT INTO dbo.events_list VALUES (200, N'QN: parameter table', N'Information about active subscriptions is stored in internal parameter tables. This event class occurs when a parameter table is created or deleted. Typically, these tables are created or deleted when the database is restarted. The TextData column contains information about the event.');
INSERT INTO dbo.events_list VALUES (201, N'QN: template', N'A query template represents a class of subscription queries. Typically, queries in the same class are identical except for their parameter values. This event class occurs when a new subscription request falls into an already existing class of (Match), a new class (Create), or a Drop class, which indicates cleanup of templates for query classes without active subscriptions. The TextData column contains information about the event.');
INSERT INTO dbo.events_list VALUES (202, N'QN: dynamics', N'Tracks internal activities of query notifications. The TextData column contains information about the event.');
INSERT INTO dbo.events_list VALUES (212, N'Bitmap Warning', N'Indicates when bitmap filters have been disabled in a query.');
INSERT INTO dbo.events_list VALUES (213, N'Database Suspect Data Page', N'Indicates when a page is added to the suspect_pages table in msdb.');
INSERT INTO dbo.events_list VALUES (214, N'CPU threshold exceeded', N'Indicates when the Resource Governor detects a query has exceeded the CPU threshold value (REQUEST_MAX_CPU_TIME_SEC).');
INSERT INTO dbo.events_list VALUES (215, N'PreConnect:Starting', N'Indicates when a LOGON trigger or Resource Governor classifier function starts execution.');
INSERT INTO dbo.events_list VALUES (216, N'PreConnect:Completed', N'Indicates when a LOGON trigger or Resource Governor classifier function completes execution.');
INSERT INTO dbo.events_list VALUES (217, N'Plan Guide Successful', N'Indicates that SQL Server successfully produced an execution plan for a query or batch that contained a plan guide.');
INSERT INTO dbo.events_list VALUES (218, N'Plan Guide Unsuccessful', N'Indicates that SQL Server could not produce an execution plan for a query or batch that contained a plan guide. SQL Server attempted to generate an execution plan for this query or batch without applying the plan guide. An invalid plan guide may be the cause of this problem. You can validate the plan guide by using the sys.fn_validate_plan_guide system function.');
INSERT INTO dbo.events_list VALUES (235, N'Audit Fulltext', N'Audit Fulltext');
SET NOCOUNT OFF;
GO
SELECT * FROM dbo.events_list;